|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Cory Sopapilla
Minmatar
|
Posted - 2009.06.11 18:59:00 -
[1]
Very nice tool. Thanks for sharing it.
The docs could definitely use an update though ;) I just kinda hacked it together after figuring out I needed to run the setup.php script thru a browser, did the "test character" thing and found it actually populated something in the DB after trying to find the config file to enter users/API keys, and finally realized it had put my limited API key in the full API field. After that it was all working.
So, 2 questions: 1) It didn't seem to work with just my limited key. Does it really need the full access key? It also kept saying I didn't have the proper role to pull some of the data (I'm CEO so that's not right). 2) Any plans on adding eve-central market pulls? Currently I pull the entire daily dump and spend about 20 hrs deleting duplicate orderIDs in a script. I'd love to be able to just pull the pieces I want and shove it in the DB ;)
Thanks!
|
Cory Sopapilla
Minmatar
|
Posted - 2009.06.25 15:07:00 -
[2]
Ok so I was building a sandbox server for API tool development and ran into the map.xml issue myself. If you put the CCP dump into a DB then add yapeal to the same DB, mapJumps is a duplicate table. So even from a fresh install, the 2 can't coexist unless you delete/rename mapJumps from CCP. It makes me worry about the next CCP data dump upgrade though. I'm going to end up losing mapJumps for yapeal most likely since I'll probably forget by then.
Any chance of looking into that and possibly renaming the yapeal mapJumps next build if this is confirmed? |
Cory Sopapilla
Minmatar
|
Posted - 2009.06.25 18:58:00 -
[3]
Cool. As always, thanks for the quick response.
|
Cory Sopapilla
Minmatar
|
Posted - 2009.07.16 15:59:00 -
[4]
Awesome. Thanks for the update. I'll check it out tonight.
Anything in the autoloader classes that would help in user registration of API info to populate the tables? I'm working on my own but don't want to reinvent the wheel if it's already done.
Thanks
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.07.21 18:02:00 -
[5]
I just added a table to my eve_db and pull the daily csv file in. I was going to work with the API pulls but that is WAY down on my list.
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.07.27 18:28:00 -
[6]
Edited by: Cory Sopapilla on 27/07/2009 18:33:18 Al, you're in our public channel so gimme a shout ;) I've done alot of the work already and we have a corp project going for an API frontend for yapeal. I have all of the csv stuff working already so maybe we could compare notes.
Basically, I grab the entire daily dump and put in a temp table but only allow the newest by date for each orderID per regionID (there are items in jita reported hundreds of times per day). Then I generate a list of unique itemIDs per regionID and delete all matches (1 at a time) and replace with the new orderIDs for that itemID in the regionID. There's lots of other stuff like deleting any that expired, etc.
What I want to do ultimately (on top of this) is pull the xml for mineral prices from the eve-central API so I can get hourly prices on those as well as an option in the front end to request new prices on other things if they have recently sent a new dump to eve-central.
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.08.17 17:05:00 -
[7]
Edited by: Cory Sopapilla on 17/08/2009 17:08:03 Edited by: Cory Sopapilla on 17/08/2009 17:07:13 Aedrine,
http://wiki.eve-id.net/APIv2_Page_Index is where you want to start. Each of the listed API calls is in the format following:
http://api.eve-online.com/account/Characters.xml.aspx?userID=1234567&apiKey=ABC123
Just start with http://api.eve-online.com and end it with the desired URI example column and fill in the ?name= input arguments. The one above would give the raw xml listing of your 3 characters if you use your own userid and apiKey as an example.
Note the cache short/long/etc timers to see how often you can pull. Don't hit longs every 5 minutes or you may end up being blocked ;)
|
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.09.14 15:15:00 -
[8]
My table serverServerStatus still shows the last known good API pull rather than a status of the API being offline. Is this something addressed in a newer version I don't have? |
Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
|
Posted - 2009.09.15 15:57:00 -
[9]
I know. Was just checking to see if you had put any timeouts to grab an error value or something in newer versions before I wrote it myself ;)
Thanks for the feedback though.
|
Cory Sopapilla
Minmatar Kiroshi Group
|
Posted - 2010.03.05 00:36:00 -
[10]
Edited by: Cory Sopapilla on 05/03/2010 00:36:42 I've tried repeatedly to get it to put in my user API stuff in the test section of the new installer. It gets to the point where I get to choose 1 of the 3 characters and starts installing but ends up having errors when trying to insert the actual user data.
Do you have anything available on just manually filling in user information on the activeAPI field? I remember it being a bunch of space separated fields before I reformatted :(
Oh *edit* Fedora Core 12 64-bit
|
|
Cory Sopapilla
Minmatar Kiroshi Group
|
Posted - 2010.03.05 21:37:00 -
[11]
Edited by: Cory Sopapilla on 05/03/2010 21:45:51 Edited by: Cory Sopapilla on 05/03/2010 21:37:50 Thanks for the reply. I think it's working but will need to make sure I got all of the tables during the install when I get home. I don't see anything for mapJumps, mapKills, Soverignty, etc and it's listed as working on the wiki. If they aren't just lemme know and I'll stop looking ;) Linkage
charResearch has nothing higher than 99.99 per day. I'll make sure that's not just something weird in the way it's being returned or a max value that needs to be increased later as well.
As always, thanks a ton for this utility. It's a major timesaver and very appreciated :)
|
Cory Sopapilla
Minmatar Kiroshi Group
|
Posted - 2010.11.19 21:05:00 -
[12]
Hi again Dragonaire.
Are there any known issues with pulling corp API stuff with the last build you have on googlecode? I'm getting about 1 successful pull a week and not sure if it's the API changes not reflected in yapeal, problems on the CCP server, or the fact that I updated PHP with a system update.
I tried reinstalling and it errors out when trying to add a test user so I'm sort of leaning towards it being a PHP compatibility error.
Looking forward to the new changes you mentioned tho! Thanks for all the hard work.
|
Cory Sopapilla
Minmatar Kiroshi Group
|
Posted - 2010.12.16 20:23:00 -
[13]
Well due to my RAID controller blowing up and taking all drives (including the backup drive off the raid set) with it, I'm starting over with setting up everything. Karma for me thinking it was funny when CCP had theirs catch on fire I guess.
I got the latest trunk build, uncompressed, copied the yapeal-example.ini to yapeal.ini, set the variables for user, pw, db, etc and left it in the /config folder. Trying to run 'php -f /path/install/createMysqlTables.php' tells me I haven't set the user, password, and DB. Is there a trick to making it find the /path/config/yapeal.ini on a freshly extracted yapeal folder? I created the DB by hand and populated it with the latest DB dump so I'm sure I got the username/pw/DB right.
|
|
|
|